﻿CREATE TABLE [dbo].[BookSubSchedule]
(
	[Id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
	[ScheduleId] NVARCHAR(50) NULL, 
	[DoctorId] NVARCHAR(50) NULL, 
	[DoctorName] NVARCHAR(50) NULL, 
	[SubjectId] NVARCHAR(50) NULL, 
	[SubjectName] NVARCHAR(50) NULL, 
	[BookCount] NVARCHAR(6) NULL, 
	[BookLimit] NVARCHAR(6) NULL, 
	[StartTime] NVARCHAR(30) NULL, 
	[EndTime] NVARCHAR(30) NULL, 
	[SpanStartTime] NVARCHAR(30) NULL, 
	[SpanEndTime] NVARCHAR(30) NULL
)
